<!DOCTYPE html>
<html>
 <head>
  <title>shows - Order Results</title>
 </head>
<div>
<img src="img001.png">
</div>
  <h1>shows</h1>
<?php
$servername = "localhost";
$username = "root";
$password = "snnucs";
$dbname = "2019";

$con = new mysqli($servername, $username, $password, $dbname);


$sql = "SELECT id,name,sex,major FROM `41812209`";
$result = $con->query($sql);

if($result->num_rows > 0){

    while($row = $result->fetch_assoc()){
        echo "id:".$row["id"]."name:".$row["name"]."<br>";
    }
}else
echo "fail";
?>
</body>
<html>